Using color coding in a drop down menu.

Ok when you choose blue from the list then it would show the word BLUE and it's color. Is that possible?

Ok, I made a list:

List (Color needed)

Extreme (Red)
High (Orange)
Moderate (Green)
Low (Yellow)

Then I went to data validation and made the list into a drop down menu.

What I would like to do Is that I when I choose option Extreme from the drop menu I created I would like it to have a Red color either text or cell color. But I would like the color to change depending on option I pick from the list.

Hi I am trying to use the combobox to fill a cell with both the figure and color. The problem is that I am totally new to excel.

1) Create your drop down list in any cell using Data Validation with fields. e.g, Low, Medium,High
2) Highlight the drop down cell.
3) Select Conditional Formatting
4) Select Highlight cell rules, more rules
5) Select Format only cells that contain
6) Change the value in the format only cells with: to Specific Text
7) Enter the text field . e.g. Low
8) Select Format tab.
9) Select the Fill tab and select your colour e.g. Green.
10) Click Ok twice.
11) Repeat steps 2 to 10 for each other drop down selection e,g, Medium for amber, and High for Red.
12) Test the colours work if not you've done somethign wrong above.
13)After all this just cut and paste the finished drop down to everywhere you want to use it.
or you can check details on
http://techrepublic.com.com/5208-623...ontent;leftCol

This was very helpful, thanks. It didn't work the first time as you need to select all the cells in the drop down box range, not just the one that contains the drop down arrow.

Use conditional formatting to color code the data.

Nichole

Thanks helped me alot!

EDIT: mamitkapoor

thanks Mamitkapoor!!

The way to use of color coding in drop down menu is really awesome and useful for us Thanks everyone and Excel forum too.

Help please -I have done all this a few times now and just cant get the colours working!! Not sure what I am doing wrong.